insert overwrite table jms_ods.tab_barscan_sign partition(dt)
select
billcode
,delivertime
,receipttype
,deliveruser
,signuser
,signedstatus
,inputuser
,inputtime
,remark
,inputsite
,deliverfee
,freightcollect
,sendstation
,destination
,realweight
,cod
,fctomonth
,fccurrency
,deliverfeecurrency
,codcurrency
,codflag
,sendsite
,destsite
,senddate
,recepitsigned
,siteaccountflag
,fcmonthlyaccount
,transferflag
,transfertime
,transferuser
,commision
,inputtype
,modifystatus
,currency
,collecttype
,shifts
,commisionremark
,pcs
,chargedweight
,contractarea
,agentflag
,scansitecode
,uploadtime
,remark3
,scanusercode
,send_deliver_usercode
,nextstationcode
,source
,remark5
,remark6
,remark4
,scansiteid
,nextstationid
,scanuserid
,send_deliver_userid
,from_unixtime(unix_timestamp(dt,'yyyyMMdd'),'yyyy-MM-dd') as dt
from ods.tab_barscan_sign where dt between '20210312' and '20210315';